CREATE TABLE [dbo].[TransWatch]
(
[TransactionNumber] [int] NOT NULL CONSTRAINT [DF_TransWatch_TransactionNumber] DEFAULT ((0)),
[InvoiceNumber] [int] NOT NULL CONSTRAINT [DF_TransWatch_InvoiceNumber] DEFAULT ((0)),
[CaptureDate] [datetime] NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [iTransWatchTransactionNumber] ON [dbo].[TransWatch] ([TransactionNumber]) ON [PRIMARY]
GO
GRANT REFERENCES ON [dbo].[TransWatch] TO [IMIS]
GRANT SELECT ON [dbo].[TransWatch] TO [IMIS]
GRANT INSERT ON [dbo].[TransWatch] TO [IMIS]
GRANT DELETE ON [dbo].[TransWatch] TO [IMIS]
GRANT UPDATE ON [dbo].[TransWatch] TO [IMIS]
GO
[dbo].[TransWatch]
